package com.example.mapper;

import com.example.entity.Employee;
import com.example.entity.MbtiQuestion;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface MbtiQuestionMapper {
    @Select("SELECT * FROM mbti_question limit 93")
    List<MbtiQuestion> findAll();

    List<MbtiQuestion> selectAll(MbtiQuestion mbtiQuestion);

    void insert(MbtiQuestion mbtiQuestion);

    void update(MbtiQuestion mbtiQuestion);

    @Delete("delete from `mbti_question` where question_id=#{id}")
    void delete(Integer id);

    @Select("select * from mbti_question where question_text = #{username}")
    MbtiQuestion selectbyusername(String username);

    List<MbtiQuestion> selectIds(@Param("list") List<Integer> questionId);
}
